package com.zygh.policeasset.mapper;

import com.zygh.policeasset.pojo.ProjectApprovalSteps;
import java.util.List;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

@Mapper
/* loaded from: police-asset-2.0-0.0.1-SNAPSHOT.jar:BOOT-INF/classes/com/zygh/policeasset/mapper/ProjectApprovalStepsMapper.class */
public interface ProjectApprovalStepsMapper {
    @Select({"select count(*)  from project_approval_steps where steps_type = #{stepsType} and steps_id = #{stepsId}"})
    int findByid(@Param("stepsType") String str, @Param("stepsId") Integer num);

    @Select({"select *  from project_approval_steps where steps_type=#{stepsType} order by steps_id"})
    @Results({@Result(property = "stepsType", column = "steps_type"), @Result(property = "stepsId", column = "steps_id")})
    List<ProjectApprovalSteps> findByType(String str);

    @Insert({"insert into project_approval_steps (steps_type,explanation,steps_id) values(#{stepsType},#{explanation},#{stepsId})"})
    int add(ProjectApprovalSteps projectApprovalSteps);

    @Update({"update project_approval_steps set steps_type=#{stepsType},explanation= #{explanation},steps_id=#{stepsId} where id = #{id}"})
    int update(ProjectApprovalSteps projectApprovalSteps);

    @Delete({"delete from project_approval_steps  where steps_type = #{stepsType}"})
    int delete(String str);
}